FaStudentPell

Logical Entity Name | FaStudentPell
Default Table Name | FaStudentPell
Physical Only | NO
Owner | dbo
Definition |
Note |

FaStudentPell Columns

ColumnName | Domain | Datatype | NULL | Definition
FaStudentPellId |  | int | NO |
SyStudentID |  | int | NO |
AwardYear |  | char(7) | NO |
TransactionID |  | char(13) | YES |
Model |  | char(1) | YES |
ModelOverride |  | char(1) | YES |
PEFC |  | int | YES |
PEFCType |  | char(1) | YES |
SEFC |  | int | YES |
SEFCType |  | char(1) | YES |
PellPaidEFC |  | int | YES |
PellPaidEFCType |  | char(1) | YES |
PellAmount |  | int | YES |
PellEnrollmentStatus |  | char(1) | YES |
VerifStatus |  | char(1) | YES |
VerifTransactionFlag |  | char(2) | YES |
VerifTrackingFlag |  | char(2) | YES |
Auto0EFCFlag |  | bit | NO |
PAEFC01 |  | int | YES |
PAEFC02 |  | int | YES |
PAEFC03 |  | int | YES |
PAEFC04 |  | int | YES |
PAEFC05 |  | int | YES |
PAEFC06 |  | int | YES |
PAEFC07 |  | int | YES |
PAEFC08 |  | int | YES |
PAEFC10 |  | int | YES |
PAEFC11 |  | int | YES |
PAEFC12 |  | int | YES |
SAEFC01 |  | int | YES |
SAEFC02 |  | int | YES |
SAEFC03 |  | int | YES |
SAEFC04 |  | int | YES |
SAEFC05 |  | int | YES |
SAEFC06 |  | int | YES |
SAEFC07 |  | int | YES |
SAEFC08 |  | int | YES |
SAEFC10 |  | int | YES |
SAEFC11 |  | int | YES |
SAEFC12 |  | int | YES |
RejectCodes |  | char(14) | YES |
RejectOverrides |  | char(12) | YES |
AssumptionOverrides |  | char(10) | YES |
FisapIncome |  | int | YES |
ParentContribution |  | int | YES |
NumPayPeriods |  | int | YES |
EnrollDate |  | datetime | YES |
AttRFMSPellID |  | char(6) | YES |
OriginationID |  | char(23) | YES |
OriginationBatchID |  | varchar(30) | YES |
OriginationStatus |  | char(1) | YES |
OriginationDate |  | datetime | YES |
OriginationProcessDate |  | datetime | YES |
OriginationRejectCodes |  | char(75) | YES |
OriginationFlags |  | char(10) | YES |
AcademicCalendar |  | char(1) | YES |
PaymentMethodology |  | char(1) | YES |
IncarceratedCode |  | char(1) | YES |
UseSecondaryEFCCode |  | char(1) | YES |
DateISIRRcvd |  | datetime | YES |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
EFCOverride |  | int | YES |
AddUserID |  | int | NO |
AcceptedTransactionID |  | char(2) | YES |
CurrentSSN |  | char(16) | YES |
StudentIdentifier |  | varchar(200) | YES |
IdentifierChanged |  | bit | NO |
CPSVerifIndicator |  | varchar(8) | YES |
CPSHighTransactionNum |  | int | YES |
RecalculatedEFC |  | bit | NO |
TotalEligibilityUsed |  | money | YES |
AddlEligibilityInd |  | bit | NO |
InstitutionalEFC |  | int | YES |
AdminRelief |  | bit | NO |
LifetimeEligUsed |  | numeric(7, 3) | NO |
ManualDependencyStatusForPLUS |  | char(1) | YES |
CareerPathwayAlternativePell |  | bit | NO |
IsFallenHeroesEligible |  | bit | NO |
PellAmount1 |  | money | YES |
SAI |  | int | YES |
ProvisionalSAI |  | int | YES |
ScheduledAmount |  | int | YES |
MaxPellFlag |  | varchar(1) | YES |
MinPellFlag |  | varchar(1) | YES |
IASGFlag |  | varchar(1) | YES |
CalcPellSchedAmount |  | bit | NO |
PellReducedCOA |  | bit | NO |
ExcludeCOAautoAdjust |  | bit | NO |
EstAwardYearCOA |  | numeric(10, 4) | YES |
ISIRPellEligible |  | bit | NO |
BypassPellAmount |  | bit | NO |
ParentContributionSecondary |  | int | YES |
PellCostOfAttend |  | numeric(10, 4) | YES |
PellCostOfAttendLTHT |  | numeric(10, 4) | YES |

FaStudentPell Primary and Unique Keys

Key Name | Key Type | Keys
UK_FaStudentPell_SyStudentID_AttRFMSPellID_AwardYear | Index | SyStudentID, AttRFMSPellID, AwardYear
FaStudentPell_FaStudentPellID_U_C_IDX | PrimaryKey | FaStudentPellId
FaStudentPell_SyStudentID_AttRFMSPellID_AwardYear_TransactionID_Model_PellEnrollmentStatus_FaStudentPellID_U_N_IDX | Index | SyStudentID, AttRFMSPellID, AwardYear, TransactionID, Model, PellEnrollmentStatus, FaStudentPellId

FaStudentPell Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
syStudent | Non-Identifying | One To Zero or More | FK_FaStudentPell_SyStudentID_syStudent_SyStudentID |  |  | SyStudentID | NO | YES
faISIR02 | Non-Identifying | Zero or One to Zero or More | FK_FaStudentPell_TransactionID_faISIR02_TransactionID |  |  | TransactionID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
faFAFSA00 | Non-Identifying | One To Zero or More | FK_faFAFSA00_FaStudentPellID_FaStudentPell_FaStudentPellID |  |  |  | NO | YES
FaFAFSA04 | Non-Identifying | One To Zero or More | FK_FaFAFSA04_FaStudentPellID_FaStudentPell_FaStudentPellID |  |  |  | NO | YES
FaFAFSA05 | Non-Identifying | One To Zero or More | FK_FaFAFSA05_FaStudentPellID_FaStudentPell_FaStudentPellID |  |  |  | NO | YES
FaFAFSA06 | Non-Identifying | One To Zero or More | FK_FaFAFSA06_FaStudentPellID_FaStudentPell_FaStudentPellID |  |  |  | NO | YES
FaFAFSA07 | Non-Identifying | One To Zero or More | FK_FaFAFSA07_FaStudentPellID_FaStudentPell_FaStudentPellID |  |  |  | NO | YES
FaFAFSA08 | Non-Identifying | One To Zero or More | FK_FaFAFSA08_FaStudentPellID_FaStudentPell_FaStudentPellID |  |  |  | NO | YES
FaFAFSA09 | Non-Identifying | One To Zero or More | FK_FaFAFSA09_FaStudentPellID_FaStudentPell_FaStudentPellID |  |  |  | NO | YES
FaFAFSA10 | Non-Identifying | One To Zero or More | FK_FaFAFSA10_FaStudentPellID_FaStudentPell_FaStudentPellID |  |  |  | NO | YES
FaFAFSA11 | Non-Identifying | One To Zero or More | FK_FaFAFSA11_FaStudentPellID_FaStudentPell_FaStudentPellID |  |  |  | NO | YES
FaFAFSA12 | Non-Identifying | One To Zero or More | FK_FaFAFSA12_FaStudentPellID_FaStudentPell_FaStudentPellID |  |  |  | NO | YES
FaFafsa | Non-Identifying | One To Zero or More | FK_FaFafsaFaStudentPellID_FaStudentPellFaStudentPellID |  |  |  | NO | YES
FaISIR04 | Non-Identifying | One To Zero or More | FK_FaISIR04_FaStudentPellID_FaStudentPell_FaStudentPellID |  |  |  | NO | YES
FaISIR05 | Non-Identifying | One To Zero or More | FK_FaISIR05_FaStudentPellID_FaStudentPell_FaStudentPellID |  |  |  | NO | YES
FaStudentAid | Identifying | One To Zero or More | FK_FaStudentAid_FaStudentAidID_FaStudentPell_FaStudentPellID |  |  |  | NO | YES
FaStudentFAFSA | Non-Identifying | One To Zero or More | FK_FaStudentFAFSAFaStudentPellId_FaStudentPellFaStudentPellId |  |  |  | NO | YES
SyAudit_FaStudentPell | Non-Identifying | One To Zero or More | FK_SyAudit_FaStudentPell_RecordID_FaStudentPell_FaStudentPellID |  |  |  | NO | YES

FaStudentPell Check Constraints

Check Constraint Name | CheckConstraint

FaStudentPell Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

FaStudentPell Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentAwardPell | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaStudentPell | NO |  |  |

FaStudentPell Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaStudentPell Data Movement Rules

Name | Type | Rule Text/Value